OpenOffice.org Base 3 |
|
| Developer(s) | Sun Microsystems |
| Stable release | 3.3 / January 25, 2011 |
| Development status | Active |
| Operating system | Cross-platform |
| Platform | Java |
| Type | Database |
| License | GNU Lesser General Public License |
| Website | www.openoffice.org |
OpenOffice.org Base ("Base" for short), a database module, initially appeared with OpenOffice.org version 2.0. As of 2010, it builds on the HSQLDB database engine written in Java.
OpenOffice.org users can connect to external full-featured SQL databases such as MySQL, PostgreSQL and Oracle through ODBC or JDBC drivers. OpenOffice.org Base can hence act as a GUI frontend for SQL views, table-design and query. In addition, OpenOffice.org has its own Form wizard to create dialog windows for form filling and updates.
Released under the terms of the GNU Lesser General Public Licence, Base is free software.
Contents |
Early provisions for integration with database information appear in the Open Office Specification version 1.0.[1]
The OpenOffice.org team evaluated another database engine, SQLite, but decided to use HSQLDB after evaluating the features, connectivity and embed quality of both database engines.
Starting with version 2.3, Base offers report-generation based on Pentaho software.[2] Base is integrated into the rest of the OpenOffice.org productivity suite. It can provide mail merge functionality in conjunction with Writer and spreadsheet integration with Calc.
The HSQLDB developers have suggested only 76% of the target has been met in the 1.8.0 release,[3] the version first integrated with OOo 2.0. (They have appealed for contributions to fulfill all the feature targets, since the core database engine itself is an independent project with no external funding.)
As a result, HSQLDB 2.0 was released in 2010 with a vast list of improvements and new features[4] HSQLDB 2.x is scheduled for inclusion in OpenOffice.org 3.4,[5] although LibreOffice has yet to commit.[6]
OpenOffice.org provides a full integrated help system, as well as tutorial documentation and a web-based wiki.
|
||||||||